Senior Analyst

Career Level: D

Introduction to role:

Are you ready to transform raw data into actionable insights? As a Data Reporting and Analytics Developer, you'll be at the forefront of driving informed decision-making and strategic initiatives within the Alexion Commercial Reporting team. Your expertise in designing, developing, and maintaining data reporting solutions and analytics platforms will empower data-driven decision-making across the organization. Ideal for candidates with strong data analysis skills, proficiency in data visualization tools, database management experience, and excellent communication skills.

Accountabilities:

• Support the Alexion Commercial Reporting team by designing, developing, validating, and maintaining Qlik Sense/Power BI dashboards and supporting data models and reporting layer development for various business units and indications.
• Understand business objectives, data sources, and key performance indicators (KPIs) to design effective solutions.
• Collaborate with business collaborators to gather, interpret, and document business rules and logic requirements for reporting use cases.
• Design and implement logical and physical data models in Snowflake that embody the agreed business rules and facilitate easy reporting.
• Create and manage SQL-based tables and views to serve as the reporting layer for Power BI/Qlik dashboards and reports.
• Monitor and tune the performance of Snowflake queries, tables, and views to ensure efficient data retrieval and reporting.
• Carry out data validation, testing, and post-production checks to ensure data accuracy and completeness across the reporting platform.
• Bridge the gap between business customers and technical developers, encouraging clear communication on data requirements and logic implementation.
• Provide timely responses to ad-hoc business queries and investigative requests.
• Maintain up-to-date documentation on data models, business rule mappings, and reporting logic.
• Proactively find opportunities to enhance data processes, optimize models, and improve reporting efficiency.

Essential Skills/Experience:

• Advanced understanding/experience with SQL, Snowflake, and Veeva CRM.
• Hands-on experience with Snowflake, SQL, and data warehousing in a reporting environment.
• Ability to create new rules and adjust existing rules in table/view creations.
• Work on creating ER diagrams and Logical data models.
• Familiarity with ETL processes and data integration concepts.
• Proven expertise in translating business requirements into technical specifications and robust data models.
• Develop and maintain comprehensive user documentation for data processes, SQL queries, and data-related workflows.
• Expertise in SQL scripting, data modelling concepts, including related skills in:
• Data warehouse
• Data architecture
• Data visualization
• Security & compliances
• Recent project experience with Qlik/PBI + experience with other BI tools.
• Experience in documenting data processes, data lineage, and reporting frameworks.

Desirable Skills/Experience:

• 6-8 years of experience in developing Data models and Architect schemas.
• Experience with database performance tuning and optimization.
• Knowledge of ETL processes and data integration workflows.
• Excellent analytical and problem-solving skills, with a keen attention to detail.
• Ability to work independently and multi-functionally in a fast-paced environment.
• Good communication and interpersonal skills.

Preferred Certifications:

• Snowflake Certified Data Architect

When we put unexpected teams in the same room, we unleash bold thinking with the power to inspire life-changing medicines. In-person working gives us the platform we need to connect, work at pace and challenge perceptions. That's why we work, on average, a minimum of three days per week from the office. But that doesn't mean we're not flexible. We balance the expectation of being in the office while respecting individual flexibility. Join us in our unique and ambitious world.

At AstraZeneca, you'll find an environment where innovation thrives! Our commitment to patients drives us to continuously innovate and create meaningful value. With a rapidly expanding portfolio, you'll enjoy the entrepreneurial spirit of a leading biotech combined with the security of a global pharma. Here, your career is not just a path but a journey to making a difference where it truly counts. You'll be empowered with tailored development programs designed for skill enhancement while fostering a deep understanding of our patient's journeys. Join us in our mission to change lives for the better!

Ready to make an impact? Apply now to join our team!

Date Posted

Closing Date

Alexion is proud to be an Equal Employment Opportunity and Affirmative Action employer. We are committed to fostering a culture of belonging where every single person can belong because of their uniqueness. The Company will not make decisions about employment, training, compensation, promotion, and other terms and conditions of employment based on race, color, religion, creed or lack thereof, sex, sexual orientation, age, ancestry, national origin, ethnicity, citizenship status, marital status, pregnancy, (including childbirth, breastfeeding, or related medical conditions), parental status (including adoption or surrogacy), military status, protected veteran status, disability, medical condition, gender identity or expression, genetic information, mental illness or other characteristics protected by law. Alexion provides reasonable accommodations to meet the needs of candidates and employees. To begin an interactive dialogue with Alexion regarding an accommodation, please contact accommodations@Alexion.com. Alexion participates in E-Verify.